# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2021年10月14日
"""
import pandas as pd

path = '../数据文件/课件027/分组.xlsx'

data = pd.read_excel(path)

data2 = data.pipe(pd.DataFrame.groupby, '班级').sum()


# print(data)
print(data2)